CREATE VIEW [dbo].[vNetContact]
AS
SELECT n.[ADDRESS_NUM_1] AS [AddressNumber1],
       n.[ADDRESS_NUM_2] AS [AddressNumber2],
       n.[ADDRESS_NUM_3] AS [AddressNumber3],
       n.[BAR_CODE] AS [BarCode],
       n.[BILL_ADDRESS_NUM] AS [BillAddressNum],
       n.[BIRTH_DATE] AS [BirthDate],
       n.[CATEGORY] AS [Category],
       n.[CHAPTER] AS [Chapter],
       n.[CO_ID] AS [CompanyId],
       n.[CO_MEMBER_TYPE] AS [CompanyMemberType],
       n.[COMPANY] AS [Company],
       n.[COMPANY_SORT] AS [CompanySort],
       n.[CONTACT_RANK] AS [ContactRank],
       n.[COUNTRY] AS [Country],
       n.[COUNTY] AS [County],
       n.[CRRT] AS [Crrt],
       n.[DATE_ADDED] AS [DateAdded],
       n.[DESIGNATION] AS [Designation],
       n.[DUP_MATCH_KEY] AS [DupMatchKey],
       n.[EMAIL] AS [Email],
       n.[EXCLUDE_DIRECTORY] AS [ExcludeDirectory],
       n.[EXCLUDE_MAIL] AS [ExcludeMail],
       n.[FAX] AS [Fax],
       n.[FULL_ADDRESS] AS [FullAddress],
       n.[FUNCTIONAL_TITLE] AS [FunctionalTitle],
       n.[GENDER] AS [Gender],
       n.[HOME_PHONE] AS [HomePhone],
       n.[INFORMAL] AS [Informal],
       n.[INTENT_TO_EDIT] AS [IntentToEdit],
       n.[JOIN_DATE] AS [JoinDate],
       n.[LAST_FIRST] AS [LastFirst],
       n.[LAST_NAME] AS [LastName],
       n.[LAST_UPDATED] AS [LastUpdated],
       n.[MAIL_ADDRESS_NUM] AS [MailAddressNumber],
       n.[MAIL_CODE] AS [MailCode],
       n.[MAJOR_KEY] AS [MajorKey],
       n.[MEMBER_RECORD] AS [IsMember],
       n.[MEMBER_STATUS] AS [MemberStatus],
       n.[MEMBER_STATUS_DATE] AS [MemberStatusDate],
       n.[MEMBER_TYPE] AS [MemberType],
       n.[MIDDLE_NAME] AS [MiddleName],
       n.[MT_CHANGE_DATE] AS [MemberTypeChangeDate],
       n.[ORG_CODE] AS [EntityCode],
       n.[PAID_THRU] AS [PaidThrough],
       n.[PREFIX] AS [Prefix],
       n.[PREVIOUS_MT] AS [PreviousMemberType],
       n.[SIC_CODE] AS [SicCode],
       n.[SOURCE_CODE] AS [SourceCode],
       n.[STATE_HOUSE] AS [StateHouse],
       n.[STATE_PROVINCE] AS [StateProvince],
       n.[STATE_SENATE] AS [StateSenate],
       n.[STATUS] AS [Status],
       n.[SUFFIX] AS [Suffix],
       n.[TITLE] AS [Title],
       n.[UPDATED_BY] AS [UpdatedBy],
       n.[US_CONGRESS] AS [UsCongress],
       n.[WEBSITE] AS [Website],
       n.[WORK_PHONE] AS [WorkPhone],
       n.[ZIP] AS [Zip],
       n.[FIRST_NAME] AS [FirstName],
       n.[CITY] AS [City],
       n.[TOLL_FREE] AS [TollFree],
       n.[BT_ID] AS [BillToID],
       n.[SHIP_ADDRESS_NUM] AS [ShipAddressNum],
       n.[ID],
       cm.[ContactKey],
       cm.[CreatedByUserKey],
       cm.[CreatedOn],
       cm.[UpdatedByUserKey],
       cm.[UpdatedOn],
       cm.[AccessKey],
       cm.[FullName],
       cm.[IsInstitute] AS [IsCompany],
       nf.[BACKORDERS] AS [Backorders],
       nf.[CREDIT_LIMIT] AS [CreditLimit],
       nf.[NO_STATEMENTS] AS [NoStatements],
       nf.[RENEW_MONTHS] AS [RenewMonths],
       nf.[RENEWED_THRU] AS [RenewedThru],
       nf.[TAX_AUTHOR_DEFAULT] AS [DefaultTaxAuthority],
       nf.[TAX_EXEMPT] AS [TaxExempt],
       nf.[TERMS_CODE] AS [DefaultTermsCode],
       nf.[USE_VAT_TAXATION] AS [VatExempt],
       nf.[VAT_COUNTRY] AS [VatCountry],
       nf.[VAT_REG_NUMBER] AS [VatRegNumber],
       cm.[ContactStatusCode],
       cm.[SortName],
       cm.[TaxIDNumber]
  FROM [dbo].[ContactMain] cm
       INNER JOIN [dbo].[Name] n ON cm.[SyncContactID] = n.[ID]
       INNER JOIN [dbo].[Name_Fin] nf ON n.[ID] = nf.[ID]

GO